************************************************************************************************************************************
************************************************************************************************************************************
*	Obtain MSA FIPS using excel and stata.
*		1) Obtain MSA FIPS column: Copy from txt into excel. Use fixed width to bring in columns.
*		2) Obtain dta for stata: Copy MSA column from Excel into Stata directly. Eliminate empty rows. Sort. Eliminate duplicates.
************************************************************************************************************************************
************************************************************************************************************************************
clear all

cd ~\data\metropolitan_stat_area_fips

local year 2018

keep if fips!=.
gen flag_msa = 1
sort fips
by fips: drop if _n!=1
d
saveold data_msa_fips_`year', replace


